Re: UNICODE and SQL

On Monday 05 May 2003 15:34, Marco Roda wrote:
> Hallo,
>
> I need to use SQL to insert some language specific characters into tables.
> In particular I am using German and Croatian specific characters. The
> database is created with UNICODE encoding.
> For instance, when trying to run from psql:
>
> INSERT INTO test VALUES (1,'Urlaubslite für nächstes Jahr');
>
> I get the following error:
>
> ERROR:  Invalid UNICODE character sequence found (0xfc7220)
>
> because of 'ü' and 'ä'.

What is your psql client encoding set to? Possibly you need
to set it to LATIN1.

Ian Barwick
barwick@gmx.net